

-- ----------------------------
-- Table structure for GEN_TABLE
-- ----------------------------
DROP TABLE "GEN_TABLE";
CREATE TABLE "GEN_TABLE" (
  "TABLE_ID" NUMBER(20,0) NOT NULL,
  "TABLE_NAME" VARCHAR2(200 BYTE) DEFAULT '',
  "TABLE_COMMENT" VARCHAR2(500 BYTE) DEFAULT '',
  "SUB_TABLE_NAME" VARCHAR2(64 BYTE) DEFAULT NULL,
  "SUB_TABLE_FK_NAME" VARCHAR2(64 BYTE) DEFAULT NULL,
  "CLASS_NAME" VARCHAR2(100 BYTE) DEFAULT '',
  "TPL_CATEGORY" VARCHAR2(200 BYTE) DEFAULT 'crud',
  "PACKAGE_NAME" VARCHAR2(100 BYTE),
  "MODULE_NAME" VARCHAR2(30 BYTE),
  "BUSINESS_NAME" VARCHAR2(30 BYTE),
  "FUNCTION_NAME" VARCHAR2(50 BYTE),
  "FUNCTION_AUTHOR" VARCHAR2(50 BYTE),
  "GEN_TYPE" CHAR(1 BYTE) DEFAULT '0',
  "GEN_PATH" VARCHAR2(200 BYTE) DEFAULT '/',
  "OPTIONS" VARCHAR2(1000 BYTE),
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE) DEFAULT NULL,
  "DATA_SOURCE_CODE" VARCHAR2(100 BYTE)
);
COMMENT ON COLUMN "GEN_TABLE"."TABLE_ID" IS '编号';
COMMENT ON COLUMN "GEN_TABLE"."TABLE_NAME" IS '表名称';
COMMENT ON COLUMN "GEN_TABLE"."TABLE_COMMENT" IS '表描述';
COMMENT ON COLUMN "GEN_TABLE"."SUB_TABLE_NAME" IS '关联子表的表名';
COMMENT ON COLUMN "GEN_TABLE"."SUB_TABLE_FK_NAME" IS '子表关联的外键名';
COMMENT ON COLUMN "GEN_TABLE"."CLASS_NAME" IS '实体类名称';
COMMENT ON COLUMN "GEN_TABLE"."TPL_CATEGORY" IS '使用的模板（crud单表操作 tree树表操作）';
COMMENT ON COLUMN "GEN_TABLE"."PACKAGE_NAME" IS '生成包路径';
COMMENT ON COLUMN "GEN_TABLE"."MODULE_NAME" IS '生成模块名';
COMMENT ON COLUMN "GEN_TABLE"."BUSINESS_NAME" IS '生成业务名';
COMMENT ON COLUMN "GEN_TABLE"."FUNCTION_NAME" IS '生成功能名';
COMMENT ON COLUMN "GEN_TABLE"."FUNCTION_AUTHOR" IS '生成功能作者';
COMMENT ON COLUMN "GEN_TABLE"."GEN_TYPE" IS '生成代码方式（0zip压缩包 1自定义路径）';
COMMENT ON COLUMN "GEN_TABLE"."GEN_PATH" IS '生成路径（不填默认项目路径）';
COMMENT ON COLUMN "GEN_TABLE"."OPTIONS" IS '其它生成选项';
COMMENT ON COLUMN "GEN_TABLE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "GEN_TABLE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "GEN_TABLE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "GEN_TABLE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "GEN_TABLE"."REMARK" IS '备注';
COMMENT ON COLUMN "GEN_TABLE"."DATA_SOURCE_CODE" IS '数据源标记';
COMMENT ON TABLE "GEN_TABLE" IS '代码生成业务表';

-- ----------------------------
-- Records of GEN_TABLE
-- ----------------------------
INSERT INTO "GEN_TABLE" VALUES ('100', 't_ex_lpyg', '劳派员工信息表', NULL, NULL, 'Lpyg', 'crud', 'com.datashare.dataentryeast', 'lpry', 'lpyg', '劳派员工信息录入', 'lhj', '0', '/', '{"parentMenuId":"2001"}', 'admin', TO_DATE('2021-11-19 16:47:39', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, 'EASTSUSER');
INSERT INTO "GEN_TABLE" VALUES ('181', 't_ex_yjzfbl', '佣金支付比例信息表', NULL, NULL, 'Yjzfbl', 'crud', 'com.datashare.dataentryods', 'yjzf', 'zfbl', '佣金支付比例信息', 'lhj', '0', '/', '{"parentMenuId":"1990"}', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'ODSUSER');

-- ----------------------------
-- Table structure for GEN_TABLE_COLUMN
-- ----------------------------
DROP TABLE "GEN_TABLE_COLUMN";
CREATE TABLE "GEN_TABLE_COLUMN" (
  "COLUMN_ID" NUMBER(20,0) NOT NULL,
  "TABLE_ID" VARCHAR2(64 BYTE),
  "COLUMN_NAME" VARCHAR2(200 BYTE),
  "COLUMN_COMMENT" VARCHAR2(500 BYTE),
  "COLUMN_TYPE" VARCHAR2(100 BYTE),
  "JAVA_TYPE" VARCHAR2(500 BYTE),
  "JAVA_FIELD" VARCHAR2(200 BYTE),
  "IS_PK" CHAR(1 BYTE),
  "IS_INCREMENT" CHAR(1 BYTE),
  "IS_REQUIRED" CHAR(1 BYTE),
  "IS_INSERT" CHAR(1 BYTE),
  "IS_EDIT" CHAR(1 BYTE),
  "IS_LIST" CHAR(1 BYTE),
  "IS_QUERY" CHAR(1 BYTE),
  "QUERY_TYPE" VARCHAR2(200 BYTE) DEFAULT 'EQ',
  "HTML_TYPE" VARCHAR2(200 BYTE),
  "DICT_TYPE" VARCHAR2(200 BYTE) DEFAULT '',
  "SORT" NUMBER(4,0),
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE
);
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."COLUMN_ID" IS '编号';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."TABLE_ID" IS '归属表编号';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."COLUMN_NAME" IS '列名称';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."COLUMN_COMMENT" IS '列描述';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."COLUMN_TYPE" IS '列类型';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."JAVA_TYPE" IS 'JAVA类型';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."JAVA_FIELD" IS 'JAVA字段名';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."IS_PK" IS '是否主键（1是）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."IS_INCREMENT" IS '是否自增（1是）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."IS_REQUIRED" IS '是否必填（1是）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."IS_INSERT" IS '是否为插入字段（1是）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."IS_EDIT" IS '是否编辑字段（1是）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."IS_LIST" IS '是否列表字段（1是）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."IS_QUERY" IS '是否查询字段（1是）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."QUERY_TYPE" IS '查询方式（等于、不等于、大于、小于、范围）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."HTML_TYPE" IS '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."DICT_TYPE" IS '字典类型';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."SORT" IS '排序';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "GEN_TABLE_COLUMN"."UPDATE_TIME" IS '更新时间';
COMMENT ON TABLE "GEN_TABLE_COLUMN" IS '代码生成业务表字段';

-- ----------------------------
-- Records of GEN_TABLE_COLUMN
-- ----------------------------
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('100', '100', 'lpyg_id', '劳派员工ID', 'number', 'Long', 'lpygId', '1', '1', NULL, NULL, NULL, NULL, NULL, 'EQ', 'input', NULL, '1', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('101', '100', 'ygxm', '员工姓名', 'varchar2', 'String', 'ygxm', '0', '0', '1', '1', '1', '1', '1', 'LIKE', 'input', NULL, '2', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('102', '100', 'csrq', '出生日期', 'date', 'Date', 'csrq', '0', '0', '1', '1', '1', '1', NULL, 'EQ', 'datetime', NULL, '3', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('103', '100', 'lxdh', '联系电话', 'varchar2', 'String', 'lxdh', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', NULL, '4', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('104', '100', 'sjc', '操作时间', 'date', 'Date', 'sjc', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'datetime', NULL, '5', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('105', '100', 'del_flag', '删除标志（0代表存在 2代表删除）', 'char', 'String', 'delFlag', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'input', NULL, '6', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('106', '100', 'create_by', '创建者', 'varchar2', 'String', 'createBy', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'input', NULL, '7', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('107', '100', 'create_time', '创建时间', 'date', 'Date', 'createTime', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'datetime', NULL, '8', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('108', '100', 'update_by', '更新者', 'varchar2', 'String', 'updateBy', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'input', NULL, '9', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('109', '100', 'update_time', '更新时间', 'date', 'Date', 'updateTime', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'datetime', NULL, '10', 'admin', TO_DATE('2021-11-19 16:47:40', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2021-12-22 15:39:11', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('394', '181', 'dqdm', '地区代码', 'varchar2', 'String', 'dqdm', '0', '0', '1', '1', '1', '1', NULL, 'EQ', 'input', NULL, '1', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('395', '181', 'dqmc', '地区名称', 'varchar2', 'String', 'dqmc', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', NULL, '2', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('396', '181', 'zfbl', '支付比例', 'number', 'Long', 'zfbl', '0', '0', '1', '1', '1', '1', NULL, 'EQ', 'input', NULL, '3', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('397', '181', 'ksrq', '开始日期', 'date', 'Date', 'ksrq', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'datetime', NULL, '4', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('398', '181', 'jsrq', '结束日期', 'date', 'Date', 'jsrq', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'datetime', NULL, '5', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('399', '181', 'sjc', '操作时间', 'date', 'Date', 'sjc', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'datetime', NULL, '6', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('400', '181', 'yjzfbl_id', '佣金支付比例ID', 'number', 'Long', 'yjzfblId', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', NULL, '7', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('401', '181', 'del_flag', '删除标志（0代表存在 2代表删除）', 'char', 'String', 'delFlag', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', NULL, '8', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('402', '181', 'create_by', '创建者', 'varchar2', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', NULL, '9', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('403', '181', 'create_time', '创建时间', 'date', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', NULL, '10', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('404', '181', 'update_by', '更新者', 'varchar2', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', NULL, '11', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "GEN_TABLE_COLUMN" VALUES ('405', '181', 'update_time', '更新时间', 'date', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', NULL, '12', 'admin', TO_DATE('2022-02-11 10:17:47', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);

-- ----------------------------
-- Table structure for SYS_CONFIG
-- ----------------------------
DROP TABLE "SYS_CONFIG";
CREATE TABLE "SYS_CONFIG" (
  "CONFIG_ID" NUMBER(20,0) NOT NULL,
  "CONFIG_NAME" VARCHAR2(100 BYTE) DEFAULT '',
  "CONFIG_KEY" VARCHAR2(100 BYTE) DEFAULT '',
  "CONFIG_VALUE" VARCHAR2(100 BYTE) DEFAULT '',
  "CONFIG_TYPE" CHAR(1 BYTE) DEFAULT 'N',
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE) DEFAULT NULL
);
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_ID" IS '参数主键seq_sys_config.nextval';
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_NAME" IS '参数名称';
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_KEY" IS '参数键名';
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_VALUE" IS '参数键值';
COMMENT ON COLUMN "SYS_CONFIG"."CONFIG_TYPE" IS '系统内置（Y是 N否）';
COMMENT ON COLUMN "SYS_CONFIG"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_CONFIG"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_CONFIG"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_CONFIG"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_CONFIG"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_CONFIG" IS '参数配置表';

-- ----------------------------
-- Records of SYS_CONFIG
-- ----------------------------
insert into sys_config values(1, '主框架页-默认皮肤样式名称',     'sys.index.skinName',            'skin-blue',     'Y', 'admin', sysdate, '', null, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow' );
insert into sys_config values(2, '用户管理-账号初始密码',         'sys.user.initPassword',         '123456',        'Y', 'admin', sysdate, '', null, '初始化密码 123456' );
insert into sys_config values(3, '主框架页-侧边栏主题',           'sys.index.sideTheme',           'theme-dark',    'Y', 'admin', sysdate, '', null, '深色主题theme-dark，浅色主题theme-light' );
insert into sys_config values(4, '账号自助-验证码开关',           'sys.account.captchaEnabled',    'true',          'Y', 'admin', sysdate, '', null, '是否开启验证码功能（true开启，false关闭）');
insert into sys_config values(5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser',      'false',         'Y', 'admin', sysdate, '', null, '是否开启注册用户功能（true开启，false关闭）');

-- ----------------------------
-- Table structure for SYS_DEPT
-- ----------------------------
DROP TABLE "SYS_DEPT";
CREATE TABLE "SYS_DEPT" (
  "DEPT_ID" NUMBER(20,0) NOT NULL,
  "PARENT_ID" NUMBER(20,0) DEFAULT 0,
  "ANCESTORS" VARCHAR2(50 BYTE) DEFAULT '',
  "DEPT_NAME" VARCHAR2(30 BYTE) DEFAULT '',
  "ORDER_NUM" NUMBER(4,0) DEFAULT 0,
  "LEADER" VARCHAR2(20 BYTE) DEFAULT NULL,
  "PHONE" VARCHAR2(11 BYTE) DEFAULT NULL,
  "EMAIL" VARCHAR2(50 BYTE) DEFAULT NULL,
  "STATUS" CHAR(1 BYTE) DEFAULT '0',
  "DEL_FLAG" CHAR(1 BYTE) DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE
);
COMMENT ON COLUMN "SYS_DEPT"."DEPT_ID" IS '部门主键seq_sys_dept.nextval';
COMMENT ON COLUMN "SYS_DEPT"."PARENT_ID" IS '父部门id';
COMMENT ON COLUMN "SYS_DEPT"."ANCESTORS" IS '祖级列表';
COMMENT ON COLUMN "SYS_DEPT"."DEPT_NAME" IS '部门名称';
COMMENT ON COLUMN "SYS_DEPT"."ORDER_NUM" IS '显示顺序';
COMMENT ON COLUMN "SYS_DEPT"."LEADER" IS '负责人';
COMMENT ON COLUMN "SYS_DEPT"."PHONE" IS '联系电话';
COMMENT ON COLUMN "SYS_DEPT"."EMAIL" IS '邮箱';
COMMENT ON COLUMN "SYS_DEPT"."STATUS" IS '部门状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_DEPT"."DEL_FLAG" IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN "SYS_DEPT"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_DEPT"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_DEPT"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_DEPT"."UPDATE_TIME" IS '更新时间';
COMMENT ON TABLE "SYS_DEPT" IS '部门信息表';

-- ----------------------------
-- Records of SYS_DEPT
-- ----------------------------
INSERT INTO "SYS_DEPT" VALUES ('110', '101', '0,100,101', '其他', '2', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2022-02-16 14:38:35', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_DEPT" VALUES ('100', '0', '0', '中国人寿', '0', '李浩君', '15822001365', '15822001365@163.com', '0', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('101', '100', '0,100', '人寿养老', '1', '李葭思', '15888888888', 'ry@qq.com', '0', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('102', '100', '0,100', '长沙分公司', '2', '若依', '15888888888', 'ry@qq.com', '0', '2', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('103', '101', '0,100,101', '党委办公室', '1', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2022-02-16 14:38:24', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_DEPT" VALUES ('104', '101', '0,100,101', '市场部门', '2', '若依', '15888888888', 'ry@qq.com', '0', '2', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('105', '101', '0,100,101', '清算部', '3', '若依', '15888888888', 'ry@qq.com', '0', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2022-02-16 14:38:35', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_DEPT" VALUES ('106', '101', '0,100,101', '财务部门', '4', '若依', '15888888888', 'ry@qq.com', '0', '2', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('107', '101', '0,100,101', '运维部门', '5', '若依', '15888888888', 'ry@qq.com', '0', '2', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('108', '102', '0,100,102', '市场部门', '1', '若依', '15888888888', 'ry@qq.com', '0', '2', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);
INSERT INTO "SYS_DEPT" VALUES ('109', '102', '0,100,102', '财务部门', '2', '若依', '15888888888', 'ry@qq.com', '0', '2', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL);

-- ----------------------------
-- Table structure for SYS_DICT_DATA
-- ----------------------------
DROP TABLE "SYS_DICT_DATA";
CREATE TABLE "SYS_DICT_DATA" (
  "DICT_CODE" NUMBER(20,0) NOT NULL,
  "DICT_SORT" NUMBER(4,0) DEFAULT 0,
  "DICT_LABEL" VARCHAR2(100 BYTE) DEFAULT '',
  "DICT_VALUE" VARCHAR2(100 BYTE) DEFAULT '',
  "DICT_TYPE" VARCHAR2(100 BYTE) DEFAULT '',
  "CSS_CLASS" VARCHAR2(100 BYTE) DEFAULT NULL,
  "LIST_CLASS" VARCHAR2(100 BYTE) DEFAULT NULL,
  "IS_DEFAULT" CHAR(1 BYTE) DEFAULT 'N',
  "STATUS" CHAR(1 BYTE) DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE) DEFAULT NULL
);
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_CODE" IS '字典主键seq_sys_dict_data.nextval';
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_SORT" IS '字典排序';
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_LABEL" IS '字典标签';
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_VALUE" IS '字典键值';
COMMENT ON COLUMN "SYS_DICT_DATA"."DICT_TYPE" IS '字典类型';
COMMENT ON COLUMN "SYS_DICT_DATA"."CSS_CLASS" IS '样式属性（其他样式扩展）';
COMMENT ON COLUMN "SYS_DICT_DATA"."LIST_CLASS" IS '表格回显样式';
COMMENT ON COLUMN "SYS_DICT_DATA"."IS_DEFAULT" IS '是否默认（Y是 N否）';
COMMENT ON COLUMN "SYS_DICT_DATA"."STATUS" IS '状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_DICT_DATA"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_DICT_DATA"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_DICT_DATA"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_DICT_DATA"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_DICT_DATA"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_DICT_DATA" IS '字典数据表';

-- ----------------------------
-- Records of SYS_DICT_DATA
-- ----------------------------

INSERT INTO "SYS_DICT_DATA" VALUES ('1', '1', '男', '0', 'sys_user_sex', NULL, NULL, 'Y', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '性别男');
INSERT INTO "SYS_DICT_DATA" VALUES ('2', '2', '女', '1', 'sys_user_sex', NULL, NULL, 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '性别女');
INSERT INTO "SYS_DICT_DATA" VALUES ('3', '3', '未知', '2', 'sys_user_sex', NULL, NULL, 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '性别未知');
INSERT INTO "SYS_DICT_DATA" VALUES ('4', '1', '显示', '0', 'sys_show_hide', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '显示菜单');
INSERT INTO "SYS_DICT_DATA" VALUES ('5', '2', '隐藏', '1', 'sys_show_hide', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '隐藏菜单');
INSERT INTO "SYS_DICT_DATA" VALUES ('6', '1', '正常', '0', 'sys_normal_disable', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '正常状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('7', '2', '停用', '1', 'sys_normal_disable', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '停用状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('8', '1', '正常', '0', 'sys_job_status', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '正常状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('9', '2', '暂停', '1', 'sys_job_status', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '停用状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('10', '1', '默认', 'DEFAULT', 'sys_job_group', NULL, NULL, 'Y', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '默认分组');
INSERT INTO "SYS_DICT_DATA" VALUES ('11', '2', '系统', 'SYSTEM', 'sys_job_group', NULL, NULL, 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '系统分组');
INSERT INTO "SYS_DICT_DATA" VALUES ('12', '1', '是', 'Y', 'sys_yes_no', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '系统默认是');
INSERT INTO "SYS_DICT_DATA" VALUES ('13', '2', '否', 'N', 'sys_yes_no', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '系统默认否');
INSERT INTO "SYS_DICT_DATA" VALUES ('14', '1', '通知', '1', 'sys_notice_type', NULL, 'warning', 'Y', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '通知');
INSERT INTO "SYS_DICT_DATA" VALUES ('15', '2', '公告', '2', 'sys_notice_type', NULL, 'success', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '公告');
INSERT INTO "SYS_DICT_DATA" VALUES ('16', '1', '正常', '0', 'sys_notice_status', NULL, 'primary', 'Y', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '正常状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('17', '2', '关闭', '1', 'sys_notice_status', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '关闭状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('18', '99', '其他', '0', 'sys_oper_type', NULL, 'info', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '其他操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('19', '1', '新增', '1', 'sys_oper_type', NULL, 'info', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '新增操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('20', '2', '修改', '2', 'sys_oper_type', NULL, 'info', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '修改操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('21', '3', '删除', '3', 'sys_oper_type', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '删除操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('22', '4', '授权', '4', 'sys_oper_type', NULL, 'primary', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '授权操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('23', '5', '导出', '5', 'sys_oper_type', NULL, 'warning', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '导出操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('24', '6', '导入', '6', 'sys_oper_type', NULL, 'warning', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '导入操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('25', '7', '强退', '7', 'sys_oper_type', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '强退操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('26', '8', '生成代码', '8', 'sys_oper_type', NULL, 'warning', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '生成操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('27', '9', '清空数据', '9', 'sys_oper_type', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '清空操作');
INSERT INTO "SYS_DICT_DATA" VALUES ('28', '1', '成功', '0', 'sys_common_status', NULL, 'primary', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '正常状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('29', '2', '失败', '1', 'sys_common_status', NULL, 'danger', 'N', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '停用状态');
INSERT INTO "SYS_DICT_DATA" VALUES ('194', '1', '统一社会信用代码', '统一社会信用代码', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('195', '2', '组织机构代码证', '组织机构代码证', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('196', '3', '税务登记证', '税务登记证', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('197', '4', '营业执照', '营业执照', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('198', '5', '事业单位法人证书', '事业单位法人证书', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('199', '6', '社会团体法人证书', '社会团体法人证书', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('200', '7', '民办非企业单位登记证书', '民办非企业单位登记证书', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('201', '8', '基金会法人登记证书', '基金会法人登记证书', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('202', '9', '工商注册号码', '工商注册号码', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('203', '10', '其他证件', '其他证件', 'JGZJLXDM', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 16:19:11', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('120', '0', '启用', '0', 'sys_status_number', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:21:43', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2021-12-23 09:23:33', 'SYYYY-MM-DD HH24:MI:SS'), NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('121', '1', '禁用', '1', 'sys_status_number', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:23:24', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('122', '0', '启用', 'true', 'sys_status_boolean', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('123', '1', '禁用', 'false', 'sys_status_boolean', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('140', '1', '居民身份证', '居民身份证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('141', '2', '临时居民身份证', '临时居民身份证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('142', '3', '户口簿', '户口簿', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('143', '4', '中国人民解放军军官证', '中国人民解放军军官证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('144', '5', '中国人民武装警察部队警官证', '中国人民武装警察部队警官证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('145', '6', '出生医学证明', '出生医学证明', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('146', '7', '中国人民解放军士兵证', '中国人民解放军士兵证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('147', '8', '中国人民武装警察部队士兵证', '中国人民武装警察部队士兵证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('148', '9', '法官证', '法官证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('149', '10', '人民警察证', '人民警察证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('150', '11', '检察官证', '检察官证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('151', '12', '律师证', '律师证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('152', '13', '记者证', '记者证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('153', '14', '工作证', '工作证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('154', '15', '学生证', '学生证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('155', '16', '离休证', '离休证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('156', '17', '老年证', '老年证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('157', '18', '残疾证', '残疾证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('158', '19', '结婚证', '结婚证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('159', '20', '离婚证', '离婚证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('160', '21', '独生子女证', '独生子女证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('161', '22', '毕业证', '毕业证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('162', '23', '肄业证', '肄业证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('163', '24', '结业证', '结业证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('164', '25', '学位证', '学位证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('165', '26', '机动车驾驶证', '机动车驾驶证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('166', '27', '外交护照', '外交护照', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('167', '28', '公务护照', '公务护照', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('168', '29', '公务普通护照', '公务普通护照', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('169', '30', '普通护照', '普通护照', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('170', '31', '外国人出入境通行证', '外国人出入境通行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('171', '32', '外国人旅行证', '外国人旅行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('172', '33', '海员证', '海员证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('173', '34', '香港特别行政区护照', '香港特别行政区护照', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('174', '35', '澳门特别行政区护照', '澳门特别行政区护照', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('175', '36', '澳门特别行政区旅行证', '澳门特别行政区旅行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('176', '37', '台湾居民来往大陆通行证', '台湾居民来往大陆通行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('177', '38', '往来港澳通行证', '往来港澳通行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('178', '39', '前往港澳通行证', '前往港澳通行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('179', '40', '港澳居民来往内地通行证', '港澳居民来往内地通行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('180', '41', '大陆居民往来台湾通行证', '大陆居民往来台湾通行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('181', '42', '因公往来香港澳门特别行政区通行证', '因公往来香港澳门特别行政区通行证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('182', '43', '香港永久性居民身份证', '香港永久性居民身份证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('183', '44', '香港居民身份证', '香港居民身份证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('184', '45', '港澳台居民居住证', '港澳台居民居住证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('185', '46', '华侨回归定居证', '华侨回归定居证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('186', '47', '台湾居民定居证', '台湾居民定居证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('187', '48', '外国人永久居留证', '外国人永久居留证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('188', '49', '外国人居留证或居留许可', '外国人居留证或居留许可', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('189', '50', '外国人临时居留证', '外国人临时居留证', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('190', '51', '入籍证书', '入籍证书', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('191', '52', '退籍证书', '退籍证书', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('192', '53', '复籍证书', '复籍证书', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('193', '54', '其他', '其他', 'GRSFZLX', NULL, 'default', 'N', '0', 'admin', TO_DATE('2021-12-23 09:24:23', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);

INSERT INTO "SYS_DICT_DATA" VALUES ('204', '0', '未定版', '0', 'jgbs_dbzt', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 17:57:09', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('205', '0', '已定版', '1', 'jgbs_dbzt', NULL, 'default', 'N', '0', 'admin', TO_DATE('2022-02-16 17:57:25', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_DATA" VALUES ('100', '1', 'orcale', '1', 'sys_databases_type', NULL, 'info', 'N', '0', 'admin', TO_DATE('2021-11-19 16:43:08', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'orcale数据库');
INSERT INTO "SYS_DICT_DATA" VALUES ('101', '2', 'mysql', '2', 'sys_databases_type', NULL, 'info', 'N', '0', 'admin', TO_DATE('2021-11-19 16:43:39', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'mysql数据库');
-- ----------------------------
-- Table structure for SYS_DICT_TYPE
-- ----------------------------
DROP TABLE "SYS_DICT_TYPE";
CREATE TABLE "SYS_DICT_TYPE" (
  "DICT_ID" NUMBER(20,0) NOT NULL,
  "DICT_NAME" VARCHAR2(100 BYTE) DEFAULT '',
  "DICT_TYPE" VARCHAR2(100 BYTE) DEFAULT '',
  "STATUS" CHAR(1 BYTE) DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE) DEFAULT NULL
);
COMMENT ON COLUMN "SYS_DICT_TYPE"."DICT_ID" IS '字典主键seq_sys_dict_type.nextval';
COMMENT ON COLUMN "SYS_DICT_TYPE"."DICT_NAME" IS '字典名称';
COMMENT ON COLUMN "SYS_DICT_TYPE"."DICT_TYPE" IS '字典类型';
COMMENT ON COLUMN "SYS_DICT_TYPE"."STATUS" IS '状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_DICT_TYPE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_DICT_TYPE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_DICT_TYPE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_DICT_TYPE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_DICT_TYPE"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_DICT_TYPE" IS '字典类型表';

-- ----------------------------
-- Records of SYS_DICT_TYPE
-- ----------------------------
INSERT INTO "SYS_DICT_TYPE" VALUES ('100', '数据库类型', 'sys_databases_type', '0', 'admin', TO_DATE('2021-11-19 16:40:34', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '数据库类型列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('120', 'ad', 'xcvad', '0', 'admin', TO_DATE('2021-11-26 09:59:03', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_TYPE" VALUES ('1', '用户性别', 'sys_user_sex', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '用户性别列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('2', '菜单状态', 'sys_show_hide', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '菜单状态列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('3', '系统开关', 'sys_normal_disable', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '系统开关列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('4', '任务状态', 'sys_job_status', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '任务状态列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('5', '任务分组', 'sys_job_group', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '任务分组列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('6', '系统是否', 'sys_yes_no', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '系统是否列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('7', '通知类型', 'sys_notice_type', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '通知类型列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('8', '通知状态', 'sys_notice_status', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '通知状态列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('9', '操作类型', 'sys_oper_type', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '操作类型列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('10', '系统状态', 'sys_common_status', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '登录状态列表');
INSERT INTO "SYS_DICT_TYPE" VALUES ('140', '状态', 'sys_status_number', '0', 'admin', TO_DATE('2021-12-23 09:19:39', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2021-12-23 09:20:58', 'SYYYY-MM-DD HH24:MI:SS'), '状态 1正常，0禁用');
INSERT INTO "SYS_DICT_TYPE" VALUES ('141', '状态', 'sys_status_boolean', '0', 'admin', TO_DATE('2021-12-23 09:20:45', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '状态 true正常，false禁用');
INSERT INTO "SYS_DICT_TYPE" VALUES ('160', '个人身份证件类型代码', 'GRSFZLX', '0', 'admin', TO_DATE('2022-02-16 15:47:26', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_TYPE" VALUES ('161', '机构证件类型', 'JGZJLXDM', '0', 'admin', TO_DATE('2022-02-16 16:08:17', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_DICT_TYPE" VALUES ('162', '定版状态', 'jgbs_dbzt', '0', 'admin', TO_DATE('2022-02-16 17:56:28', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);

-- ----------------------------
-- Table structure for SYS_JOB
-- ----------------------------
DROP TABLE "SYS_JOB";
CREATE TABLE "SYS_JOB" (
  "JOB_ID" NUMBER(20,0) NOT NULL,
  "JOB_NAME" VARCHAR2(64 BYTE) DEFAULT '' NOT NULL,
  "JOB_GROUP" VARCHAR2(64 BYTE) DEFAULT '' NOT NULL,
  "INVOKE_TARGET" VARCHAR2(500 BYTE) NOT NULL,
  "CRON_EXPRESSION" VARCHAR2(255 BYTE) DEFAULT '',
  "MISFIRE_POLICY" VARCHAR2(20 BYTE) DEFAULT '3',
  "CONCURRENT" CHAR(1 BYTE) DEFAULT '1',
  "STATUS" CHAR(1 BYTE) DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE) DEFAULT ''
);
COMMENT ON COLUMN "SYS_JOB"."JOB_ID" IS '任务主键seq_sys_job.nextval';
COMMENT ON COLUMN "SYS_JOB"."JOB_NAME" IS '任务名称';
COMMENT ON COLUMN "SYS_JOB"."JOB_GROUP" IS '任务组名';
COMMENT ON COLUMN "SYS_JOB"."INVOKE_TARGET" IS '调用目标字符串';
COMMENT ON COLUMN "SYS_JOB"."CRON_EXPRESSION" IS 'cron执行表达式';
COMMENT ON COLUMN "SYS_JOB"."MISFIRE_POLICY" IS '计划执行错误策略（1立即执行 2执行一次 3放弃执行）';
COMMENT ON COLUMN "SYS_JOB"."CONCURRENT" IS '是否并发执行（0允许 1禁止）';
COMMENT ON COLUMN "SYS_JOB"."STATUS" IS '状态（0正常 1暂停）';
COMMENT ON COLUMN "SYS_JOB"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_JOB"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_JOB"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_JOB"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_JOB"."REMARK" IS '备注信息';
COMMENT ON TABLE "SYS_JOB" IS '定时任务调度表';

-- ----------------------------
-- Records of SYS_JOB
-- ----------------------------
INSERT INTO "SYS_JOB" VALUES ('1', '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_JOB" VALUES ('2', '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(''ry'')', '0/15 * * * * ?', '3', '1', '1', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_JOB" VALUES ('3', '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(''ry'', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);

-- ----------------------------
-- Table structure for SYS_JOB_LOG
-- ----------------------------
DROP TABLE "SYS_JOB_LOG";
CREATE TABLE "SYS_JOB_LOG" (
  "JOB_LOG_ID" NUMBER(20,0) NOT NULL,
  "JOB_NAME" VARCHAR2(64 BYTE) NOT NULL,
  "JOB_GROUP" VARCHAR2(64 BYTE) NOT NULL,
  "INVOKE_TARGET" VARCHAR2(500 BYTE) NOT NULL,
  "JOB_MESSAGE" VARCHAR2(500 BYTE),
  "STATUS" CHAR(1 BYTE) DEFAULT '0',
  "EXCEPTION_INFO" VARCHAR2(2000 BYTE) DEFAULT '',
  "CREATE_TIME" DATE
);
COMMENT ON COLUMN "SYS_JOB_LOG"."JOB_LOG_ID" IS '日志主键seq_sys_job_log.nextval';
COMMENT ON COLUMN "SYS_JOB_LOG"."JOB_NAME" IS '任务名称';
COMMENT ON COLUMN "SYS_JOB_LOG"."JOB_GROUP" IS '任务组名';
COMMENT ON COLUMN "SYS_JOB_LOG"."INVOKE_TARGET" IS '调用目标字符串';
COMMENT ON COLUMN "SYS_JOB_LOG"."JOB_MESSAGE" IS '日志信息';
COMMENT ON COLUMN "SYS_JOB_LOG"."STATUS" IS '执行状态（0正常 1失败）';
COMMENT ON COLUMN "SYS_JOB_LOG"."EXCEPTION_INFO" IS '异常信息';
COMMENT ON COLUMN "SYS_JOB_LOG"."CREATE_TIME" IS '创建时间';
COMMENT ON TABLE "SYS_JOB_LOG" IS '定时任务调度日志表';

-- ----------------------------
-- Records of SYS_JOB_LOG
-- ----------------------------
INSERT INTO "SYS_JOB_LOG" VALUES ('2', '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(''ry'')', '系统默认（有参） 总共耗时：0毫秒', '0', NULL, TO_DATE('2022-02-21 10:44:01', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_JOB_LOG" VALUES ('1', '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '系统默认（无参） 总共耗时：2毫秒', '0', NULL, TO_DATE('2022-02-21 10:43:58', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "SYS_JOB_LOG" VALUES ('3', '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(''ry'', true, 2000L, 316.50D, 100)', '系统默认（多参） 总共耗时：1毫秒', '0', NULL, TO_DATE('2022-02-21 10:44:04', 'SYYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for SYS_LOGININFOR
-- ----------------------------
DROP TABLE "SYS_LOGININFOR";
CREATE TABLE "SYS_LOGININFOR" (
  "INFO_ID" NUMBER(20,0) NOT NULL,
  "USER_NAME" VARCHAR2(50 BYTE) DEFAULT '',
  "IPADDR" VARCHAR2(128 BYTE) DEFAULT '',
  "LOGIN_LOCATION" VARCHAR2(255 BYTE) DEFAULT '',
  "BROWSER" VARCHAR2(50 BYTE) DEFAULT '',
  "OS" VARCHAR2(50 BYTE) DEFAULT '',
  "STATUS" CHAR(1 BYTE) DEFAULT '0',
  "MSG" VARCHAR2(255 BYTE) DEFAULT '',
  "LOGIN_TIME" DATE
);
COMMENT ON COLUMN "SYS_LOGININFOR"."INFO_ID" IS '访问主键seq_seq_sys_logininfor.nextval';
COMMENT ON COLUMN "SYS_LOGININFOR"."USER_NAME" IS '登录账号';
COMMENT ON COLUMN "SYS_LOGININFOR"."IPADDR" IS '登录IP地址';
COMMENT ON COLUMN "SYS_LOGININFOR"."LOGIN_LOCATION" IS '登录地点';
COMMENT ON COLUMN "SYS_LOGININFOR"."BROWSER" IS '浏览器类型';
COMMENT ON COLUMN "SYS_LOGININFOR"."OS" IS '操作系统';
COMMENT ON COLUMN "SYS_LOGININFOR"."STATUS" IS '登录状态（0成功 1失败）';
COMMENT ON COLUMN "SYS_LOGININFOR"."MSG" IS '提示消息';
COMMENT ON COLUMN "SYS_LOGININFOR"."LOGIN_TIME" IS '访问时间';
COMMENT ON TABLE "SYS_LOGININFOR" IS '系统访问记录';

-- ----------------------------
-- Table structure for SYS_MENU
-- ----------------------------
DROP TABLE "SYS_MENU";
CREATE TABLE "SYS_MENU" (
  "MENU_ID" NUMBER(20,0) NOT NULL,
  "MENU_NAME" VARCHAR2(50 BYTE) NOT NULL,
  "PARENT_ID" NUMBER(20,0) DEFAULT 0,
  "ORDER_NUM" NUMBER(4,0) DEFAULT 0,
  "PATH" VARCHAR2(200 BYTE) DEFAULT '',
  "COMPONENT" VARCHAR2(255 BYTE) DEFAULT NULL,
  "QUERY" VARCHAR2(255 BYTE) DEFAULT NULL,
  "IS_FRAME" NUMBER(1,0) DEFAULT 1,
  "IS_CACHE" NUMBER(1,0) DEFAULT 0,
  "MENU_TYPE" CHAR(1 BYTE) DEFAULT '',
  "VISIBLE" CHAR(1 BYTE) DEFAULT 0,
  "STATUS" CHAR(1 BYTE) DEFAULT 0,
  "PERMS" VARCHAR2(100 BYTE) DEFAULT NULL,
  "ICON" VARCHAR2(100 BYTE) DEFAULT '#',
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE) DEFAULT ''
);
COMMENT ON COLUMN "SYS_MENU"."MENU_ID" IS '菜单主键seq_sys_post.nextval';
COMMENT ON COLUMN "SYS_MENU"."MENU_NAME" IS '菜单名称';
COMMENT ON COLUMN "SYS_MENU"."PARENT_ID" IS '父菜单ID';
COMMENT ON COLUMN "SYS_MENU"."ORDER_NUM" IS '显示顺序';
COMMENT ON COLUMN "SYS_MENU"."PATH" IS '请求地址';
COMMENT ON COLUMN "SYS_MENU"."COMPONENT" IS '路由地址';
COMMENT ON COLUMN "SYS_MENU"."QUERY" IS '路由参数';
COMMENT ON COLUMN "SYS_MENU"."IS_FRAME" IS '是否为外链（0是 1否）';
COMMENT ON COLUMN "SYS_MENU"."IS_CACHE" IS '是否缓存（0缓存 1不缓存）';
COMMENT ON COLUMN "SYS_MENU"."MENU_TYPE" IS '菜单类型（M目录 C菜单 F按钮）';
COMMENT ON COLUMN "SYS_MENU"."VISIBLE" IS '菜单状态（0显示 1隐藏）';
COMMENT ON COLUMN "SYS_MENU"."STATUS" IS '菜单状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_MENU"."PERMS" IS '权限标识';
COMMENT ON COLUMN "SYS_MENU"."ICON" IS '菜单图标';
COMMENT ON COLUMN "SYS_MENU"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_MENU"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_MENU"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_MENU"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_MENU"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_MENU" IS '菜单权限表';

-- ----------------------------
-- 初始化-菜单信息表数据
-- Records of SYS_MENU
-- ----------------------------
-- ----------------------------
-- 初始化-菜单信息表数据
-- ----------------------------
-- 一级菜单
insert into sys_menu values('1', '系统管理', '0', '1', 'system',           null, '', 1, 0, 'M', '0', '0', '', 'system',   'admin', sysdate, '', null, '系统管理目录');
insert into sys_menu values('2', '系统监控', '0', '2', 'monitor',          null, '', 1, 0, 'M', '0', '0', '', 'monitor',  'admin', sysdate, '', null, '系统监控目录');
insert into sys_menu values('3', '系统工具', '0', '3', 'tool',             null, '', 1, 0, 'M', '0', '0', '', 'tool',     'admin', sysdate, '', null, '系统工具目录');
insert into sys_menu values('4', '若依官网', '0', '4', 'http://ruoyi.vip', null, '', 0, 0, 'M', '0', '0', '', 'guide',    'admin', sysdate, '', null, '若依官网地址');
-- 二级菜单
insert into sys_menu values('100',  '用户管理', '1',   '1', 'user',       'system/user/index',        '', 1, 0, 'C', '0', '0', 'system:user:list',        'user',          'admin', sysdate, '', null, '用户管理菜单');
insert into sys_menu values('101',  '角色管理', '1',   '2', 'role',       'system/role/index',        '', 1, 0, 'C', '0', '0', 'system:role:list',        'peoples',       'admin', sysdate, '', null, '角色管理菜单');
insert into sys_menu values('102',  '菜单管理', '1',   '3', 'menu',       'system/menu/index',        '', 1, 0, 'C', '0', '0', 'system:menu:list',        'tree-table',    'admin', sysdate, '', null, '菜单管理菜单');
insert into sys_menu values('103',  '部门管理', '1',   '4', 'dept',       'system/dept/index',        '', 1, 0, 'C', '0', '0', 'system:dept:list',        'tree',          'admin', sysdate, '', null, '部门管理菜单');
insert into sys_menu values('104',  '岗位管理', '1',   '5', 'post',       'system/post/index',        '', 1, 0, 'C', '0', '0', 'system:post:list',        'post',          'admin', sysdate, '', null, '岗位管理菜单');
insert into sys_menu values('105',  '字典管理', '1',   '6', 'dict',       'system/dict/index',        '', 1, 0, 'C', '0', '0', 'system:dict:list',        'dict',          'admin', sysdate, '', null, '字典管理菜单');
insert into sys_menu values('106',  '参数设置', '1',   '7', 'config',     'system/config/index',      '', 1, 0, 'C', '0', '0', 'system:config:list',      'edit',          'admin', sysdate, '', null, '参数设置菜单');
insert into sys_menu values('107',  '通知公告', '1',   '8', 'notice',     'system/notice/index',      '', 1, 0, 'C', '0', '0', 'system:notice:list',      'message',       'admin', sysdate, '', null, '通知公告菜单');
insert into sys_menu values('108',  '日志管理', '1',   '9', 'log',        '',                         '', 1, 0, 'M', '0', '0', '',                        'log',           'admin', sysdate, '', null, '日志管理菜单');
insert into sys_menu values('109',  '在线用户', '2',   '1', 'online',     'monitor/online/index',     '', 1, 0, 'C', '0', '0', 'monitor:online:list',     'online',        'admin', sysdate, '', null, '在线用户菜单');
insert into sys_menu values('110',  '定时任务', '2',   '2', 'job',        'monitor/job/index',        '', 1, 0, 'C', '0', '0', 'monitor:job:list',        'job',           'admin', sysdate, '', null, '定时任务菜单');
insert into sys_menu values('111',  '数据监控', '2',   '3', 'druid',      'monitor/druid/index',      '', 1, 0, 'C', '0', '0', 'monitor:druid:list',      'druid',         'admin', sysdate, '', null, '数据监控菜单');
insert into sys_menu values('112',  '服务监控', '2',   '4', 'server',     'monitor/server/index',     '', 1, 0, 'C', '0', '0', 'monitor:server:list',     'server',        'admin', sysdate, '', null, '服务监控菜单');
insert into sys_menu values('113',  '缓存监控', '2',   '5', 'cache',      'monitor/cache/index',      '', 1, 0, 'C', '0', '0', 'monitor:cache:list',      'redis',         'admin', sysdate, '', null, '缓存监控菜单');
insert into sys_menu values('114',  '缓存列表', '2',   '6', 'cacheList',  'monitor/cache/list',       '', 1, 0, 'C', '0', '0', 'monitor:cache:list',      'redis-list',    'admin', sysdate, '', null, '缓存列表菜单');
insert into sys_menu values('115',  '表单构建', '3',   '1', 'build',      'tool/build/index',         '', 1, 0, 'C', '0', '0', 'tool:build:list',         'build',         'admin', sysdate, '', null, '表单构建菜单');
insert into sys_menu values('116',  '代码生成', '3',   '2', 'gen',        'tool/gen/index',           '', 1, 0, 'C', '0', '0', 'tool:gen:list',           'code',          'admin', sysdate, '', null, '代码生成菜单');
insert into sys_menu values('117',  '系统接口', '3',   '3', 'swagger',    'tool/swagger/index',       '', 1, 0, 'C', '0', '0', 'tool:swagger:list',       'swagger',       'admin', sysdate, '', null, '系统接口菜单');
-- 三级菜单
insert into sys_menu values('500',  '操作日志', '108', '1', 'operlog',    'monitor/operlog/index',    '', 1, 0, 'C', '0', '0', 'monitor:operlog:list',    'form',          'admin', sysdate, '', null, '操作日志菜单');
insert into sys_menu values('501',  '登录日志', '108', '2', 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor',    'admin', sysdate, '', null, '登录日志菜单');
-- 用户管理按钮
insert into sys_menu values('1000', '用户查询', '100', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:query',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1001', '用户新增', '100', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:add',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1002', '用户修改', '100', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit',           '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1003', '用户删除', '100', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1004', '用户导出', '100', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:export',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1005', '用户导入', '100', '6',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:import',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1006', '重置密码', '100', '7',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd',       '#', 'admin', sysdate, '', null, '');
-- 角色管理按钮
insert into sys_menu values('1007', '角色查询', '101', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:query',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1008', '角色新增', '101', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:add',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1009', '角色修改', '101', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit',           '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1010', '角色删除', '101', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1011', '角色导出', '101', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:export',         '#', 'admin', sysdate, '', null, '');
-- 菜单管理按钮
insert into sys_menu values('1012', '菜单查询', '102', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1013', '菜单新增', '102', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1014', '菜单修改', '102', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit',           '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1015', '菜单删除', '102', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove',         '#', 'admin', sysdate, '', null, '');
-- 部门管理按钮
insert into sys_menu values('1016', '部门查询', '103', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1017', '部门新增', '103', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1018', '部门修改', '103', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit',           '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1019', '部门删除', '103', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove',         '#', 'admin', sysdate, '', null, '');
-- 岗位管理按钮
insert into sys_menu values('1020', '岗位查询', '104', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:query',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1021', '岗位新增', '104', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:add',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1022', '岗位修改', '104', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit',           '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1023', '岗位删除', '104', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1024', '岗位导出', '104', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:export',         '#', 'admin', sysdate, '', null, '');
-- 字典管理按钮
insert into sys_menu values('1025', '字典查询', '105', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1026', '字典新增', '105', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1027', '字典修改', '105', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit',           '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1028', '字典删除', '105', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1029', '字典导出', '105', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export',         '#', 'admin', sysdate, '', null, '');
-- 参数设置按钮
insert into sys_menu values('1030', '参数查询', '106', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query',        '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1031', '参数新增', '106', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1032', '参数修改', '106', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1033', '参数删除', '106', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove',       '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1034', '参数导出', '106', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export',       '#', 'admin', sysdate, '', null, '');
-- 通知公告按钮
insert into sys_menu values('1035', '公告查询', '107', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query',        '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1036', '公告新增', '107', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1037', '公告修改', '107', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1038', '公告删除', '107', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove',       '#', 'admin', sysdate, '', null, '');
-- 操作日志按钮
insert into sys_menu values('1039', '操作查询', '500', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query',      '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1040', '操作删除', '500', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove',     '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1041', '日志导出', '500', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export',     '#', 'admin', sysdate, '', null, '');
-- 登录日志按钮
insert into sys_menu values('1042', '登录查询', '501', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query',   '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1043', '登录删除', '501', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove',  '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1044', '日志导出', '501', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export',  '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1045', '账户解锁', '501', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock',  '#', 'admin', sysdate, '', null, '');
-- 在线用户按钮
insert into sys_menu values('1046', '在线查询', '109', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query',       '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1047', '批量强退', '109', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1048', '单条强退', '109', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate, '', null, '');
-- 定时任务按钮
insert into sys_menu values('1049', '任务查询', '110', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query',          '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1050', '任务新增', '110', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1051', '任务修改', '110', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit',           '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1052', '任务删除', '110', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove',         '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1053', '状态修改', '110', '5', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus',   '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1054', '任务导出', '110', '6', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export',         '#', 'admin', sysdate, '', null, '');
-- 代码生成按钮
insert into sys_menu values('1055', '生成查询', '116', '1', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query',             '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1056', '生成修改', '116', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit',              '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1057', '生成删除', '116', '3', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1058', '导入代码', '116', '4', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import',            '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1059', '预览代码', '116', '5', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview',           '#', 'admin', sysdate, '', null, '');
insert into sys_menu values('1060', '生成代码', '116', '6', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code',              '#', 'admin', sysdate, '', null, '');

-- ----------------------------
-- Table structure for SYS_NOTICE
-- ----------------------------
DROP TABLE "SYS_NOTICE";
CREATE TABLE "SYS_NOTICE" (
  "NOTICE_ID" NUMBER(20,0) NOT NULL,
  "NOTICE_TITLE" VARCHAR2(50 BYTE) NOT NULL,
  "NOTICE_TYPE" CHAR(1 BYTE) NOT NULL,
  "NOTICE_CONTENT" CLOB DEFAULT NULL,
  "STATUS" CHAR(1 BYTE) DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(255 BYTE) DEFAULT NULL
);
COMMENT ON COLUMN "SYS_NOTICE"."NOTICE_ID" IS '公告主键seq_sys_notice.nextval';
COMMENT ON COLUMN "SYS_NOTICE"."NOTICE_TITLE" IS '公告标题';
COMMENT ON COLUMN "SYS_NOTICE"."NOTICE_TYPE" IS '公告类型（1通知 2公告）';
COMMENT ON COLUMN "SYS_NOTICE"."NOTICE_CONTENT" IS '公告内容';
COMMENT ON COLUMN "SYS_NOTICE"."STATUS" IS '公告状态（0正常 1关闭）';
COMMENT ON COLUMN "SYS_NOTICE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_NOTICE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_NOTICE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_NOTICE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_NOTICE"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_NOTICE" IS '通知公告表';

-- ----------------------------
-- Records of SYS_NOTICE
-- ----------------------------
INSERT INTO "SYS_NOTICE" VALUES ('1', '温馨提醒：2018-07-01 若依新版本发布啦', '2', '新版本内容', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '管理员');
INSERT INTO "SYS_NOTICE" VALUES ('2', '维护通知：2018-07-01 若依系统凌晨维护', '1', '维护内容', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '管理员');

-- ----------------------------
-- Table structure for SYS_OPER_LOG
-- ----------------------------
DROP TABLE "SYS_OPER_LOG";
CREATE TABLE "SYS_OPER_LOG" (
  "OPER_ID" NUMBER(20,0) NOT NULL,
  "TITLE" VARCHAR2(50 BYTE) DEFAULT '',
  "BUSINESS_TYPE" NUMBER(2,0) DEFAULT 0,
  "METHOD" VARCHAR2(100 BYTE) DEFAULT '',
  "REQUEST_METHOD" VARCHAR2(10 BYTE) DEFAULT '',
  "OPERATOR_TYPE" NUMBER(1,0) DEFAULT 0,
  "OPER_NAME" VARCHAR2(50 BYTE) DEFAULT '',
  "DEPT_NAME" VARCHAR2(50 BYTE) DEFAULT '',
  "OPER_URL" VARCHAR2(255 BYTE) DEFAULT '',
  "OPER_IP" VARCHAR2(128 BYTE) DEFAULT '',
  "OPER_LOCATION" VARCHAR2(255 BYTE) DEFAULT '',
  "OPER_PARAM" VARCHAR2(2500 BYTE) DEFAULT '',
  "JSON_RESULT" VARCHAR2(2000 BYTE) DEFAULT '',
  "STATUS" NUMBER(1,0) DEFAULT 0,
  "ERROR_MSG" VARCHAR2(2000 BYTE) DEFAULT '',
  "OPER_TIME" DATE
);
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_ID" IS '日志主键seq_sys_oper_log.nextval';
COMMENT ON COLUMN "SYS_OPER_LOG"."TITLE" IS '模块标题';
COMMENT ON COLUMN "SYS_OPER_LOG"."BUSINESS_TYPE" IS '业务类型（0其它 1新增 2修改 3删除）';
COMMENT ON COLUMN "SYS_OPER_LOG"."METHOD" IS '方法名称';
COMMENT ON COLUMN "SYS_OPER_LOG"."REQUEST_METHOD" IS '请求方式';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPERATOR_TYPE" IS '操作类别（0其它 1后台用户 2手机端用户）';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_NAME" IS '操作人员';
COMMENT ON COLUMN "SYS_OPER_LOG"."DEPT_NAME" IS '部门名称';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_URL" IS '请求URL';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_IP" IS '主机地址';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_LOCATION" IS '操作地点';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_PARAM" IS '请求参数';
COMMENT ON COLUMN "SYS_OPER_LOG"."JSON_RESULT" IS '返回参数';
COMMENT ON COLUMN "SYS_OPER_LOG"."STATUS" IS '操作状态（0正常 1异常）';
COMMENT ON COLUMN "SYS_OPER_LOG"."ERROR_MSG" IS '错误消息';
COMMENT ON COLUMN "SYS_OPER_LOG"."OPER_TIME" IS '操作时间';
COMMENT ON TABLE "SYS_OPER_LOG" IS '操作日志记录';

-- ----------------------------
-- Table structure for SYS_POST
-- ----------------------------
DROP TABLE "SYS_POST";
CREATE TABLE "SYS_POST" (
  "POST_ID" NUMBER(20,0) NOT NULL,
  "POST_CODE" VARCHAR2(64 BYTE) NOT NULL,
  "POST_NAME" VARCHAR2(50 BYTE) NOT NULL,
  "POST_SORT" NUMBER(4,0) NOT NULL,
  "STATUS" CHAR(1 BYTE) NOT NULL,
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE)
);
COMMENT ON COLUMN "SYS_POST"."POST_ID" IS '岗位主键seq_sys_post.nextval';
COMMENT ON COLUMN "SYS_POST"."POST_CODE" IS '岗位编码';
COMMENT ON COLUMN "SYS_POST"."POST_NAME" IS '岗位名称';
COMMENT ON COLUMN "SYS_POST"."POST_SORT" IS '显示顺序';
COMMENT ON COLUMN "SYS_POST"."STATUS" IS '状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_POST"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_POST"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_POST"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_POST"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_POST"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_POST" IS '岗位信息表';

-- ----------------------------
-- Records of SYS_POST
-- ----------------------------
INSERT INTO "SYS_POST" VALUES ('1', 'ceo', '董事长', '1', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_POST" VALUES ('2', 'se', '项目经理', '2', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_POST" VALUES ('3', 'hr', '人力资源', '3', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
INSERT INTO "SYS_POST" VALUES ('4', 'user', '普通员工', '4', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);

-- ----------------------------
-- Table structure for SYS_ROLE
-- ----------------------------
DROP TABLE "SYS_ROLE";
CREATE TABLE "SYS_ROLE" (
  "ROLE_ID" NUMBER(20,0) NOT NULL,
  "ROLE_NAME" VARCHAR2(30 BYTE) NOT NULL,
  "ROLE_KEY" VARCHAR2(100 BYTE) NOT NULL,
  "ROLE_SORT" NUMBER(4,0) NOT NULL,
  "DATA_SCOPE" CHAR(1 BYTE) DEFAULT '1',
  "MENU_CHECK_STRICTLY" NUMBER(1,0) DEFAULT 1,
  "DEPT_CHECK_STRICTLY" NUMBER(1,0) DEFAULT 1,
  "STATUS" CHAR(1 BYTE) NOT NULL,
  "DEL_FLAG" CHAR(1 BYTE) DEFAULT '0',
  "CREATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE) DEFAULT NULL
);
COMMENT ON COLUMN "SYS_ROLE"."ROLE_ID" IS '角色主键seq_sys_post.nextval';
COMMENT ON COLUMN "SYS_ROLE"."ROLE_NAME" IS '角色名称';
COMMENT ON COLUMN "SYS_ROLE"."ROLE_KEY" IS '角色权限字符串';
COMMENT ON COLUMN "SYS_ROLE"."ROLE_SORT" IS '显示顺序';
COMMENT ON COLUMN "SYS_ROLE"."DATA_SCOPE" IS '数据范围（1：全部数据权限 2：自定数据权限）';
COMMENT ON COLUMN "SYS_ROLE"."MENU_CHECK_STRICTLY" IS '菜单树选择项是否关联显示';
COMMENT ON COLUMN "SYS_ROLE"."DEPT_CHECK_STRICTLY" IS '部门树选择项是否关联显示';
COMMENT ON COLUMN "SYS_ROLE"."STATUS" IS '角色状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_ROLE"."DEL_FLAG" IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN "SYS_ROLE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_ROLE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_ROLE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_ROLE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_ROLE"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_ROLE" IS '角色信息表';

-- ----------------------------
-- Records of SYS_ROLE
-- ----------------------------
INSERT INTO "SYS_ROLE" VALUES ('1', '超级管理员', 'admin', '1', '1', '1', '1', '0', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '超级管理员');
INSERT INTO "SYS_ROLE" VALUES ('2', '办公室', 'common', '2', '2', '1', '1', '0', '0', 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2021-11-19 10:23:33', 'SYYYY-MM-DD HH24:MI:SS'), '普通角色');

-- ----------------------------
-- Table structure for SYS_ROLE_DEPT
-- ----------------------------
DROP TABLE "SYS_ROLE_DEPT";
CREATE TABLE "SYS_ROLE_DEPT" (
  "ROLE_ID" NUMBER(20,0) NOT NULL,
  "DEPT_ID" NUMBER(20,0) NOT NULL
);
COMMENT ON COLUMN "SYS_ROLE_DEPT"."ROLE_ID" IS '角色ID';
COMMENT ON COLUMN "SYS_ROLE_DEPT"."DEPT_ID" IS '部门ID';
COMMENT ON TABLE "SYS_ROLE_DEPT" IS '角色和部门关联表';

-- ----------------------------
-- Records of SYS_ROLE_DEPT
-- ----------------------------
INSERT INTO "SYS_ROLE_DEPT" VALUES ('2', '100');
INSERT INTO "SYS_ROLE_DEPT" VALUES ('2', '101');
INSERT INTO "SYS_ROLE_DEPT" VALUES ('2', '105');

-- ----------------------------
-- Table structure for SYS_ROLE_MENU
-- ----------------------------
DROP TABLE "SYS_ROLE_MENU";
CREATE TABLE "SYS_ROLE_MENU" (
  "ROLE_ID" NUMBER(20,0) NOT NULL,
  "MENU_ID" NUMBER(20,0) NOT NULL
);
COMMENT ON COLUMN "SYS_ROLE_MENU"."ROLE_ID" IS '角色ID';
COMMENT ON COLUMN "SYS_ROLE_MENU"."MENU_ID" IS '菜单ID';
COMMENT ON TABLE "SYS_ROLE_MENU" IS '角色和菜单关联表';

-- ----------------------------
-- Records of SYS_ROLE_MENU
-- 初始化-角色和菜单关联表数据
-- ----------------------------
insert into sys_role_menu values ('2', '1');
insert into sys_role_menu values ('2', '2');
insert into sys_role_menu values ('2', '3');
insert into sys_role_menu values ('2', '4');
insert into sys_role_menu values ('2', '100');
insert into sys_role_menu values ('2', '101');
insert into sys_role_menu values ('2', '102');
insert into sys_role_menu values ('2', '103');
insert into sys_role_menu values ('2', '104');
insert into sys_role_menu values ('2', '105');
insert into sys_role_menu values ('2', '106');
insert into sys_role_menu values ('2', '107');
insert into sys_role_menu values ('2', '108');
insert into sys_role_menu values ('2', '109');
insert into sys_role_menu values ('2', '110');
insert into sys_role_menu values ('2', '111');
insert into sys_role_menu values ('2', '112');
insert into sys_role_menu values ('2', '113');
insert into sys_role_menu values ('2', '114');
insert into sys_role_menu values ('2', '115');
insert into sys_role_menu values ('2', '116');
insert into sys_role_menu values ('2', '117');
insert into sys_role_menu values ('2', '500');
insert into sys_role_menu values ('2', '501');
insert into sys_role_menu values ('2', '1000');
insert into sys_role_menu values ('2', '1001');
insert into sys_role_menu values ('2', '1002');
insert into sys_role_menu values ('2', '1003');
insert into sys_role_menu values ('2', '1004');
insert into sys_role_menu values ('2', '1005');
insert into sys_role_menu values ('2', '1006');
insert into sys_role_menu values ('2', '1007');
insert into sys_role_menu values ('2', '1008');
insert into sys_role_menu values ('2', '1009');
insert into sys_role_menu values ('2', '1010');
insert into sys_role_menu values ('2', '1011');
insert into sys_role_menu values ('2', '1012');
insert into sys_role_menu values ('2', '1013');
insert into sys_role_menu values ('2', '1014');
insert into sys_role_menu values ('2', '1015');
insert into sys_role_menu values ('2', '1016');
insert into sys_role_menu values ('2', '1017');
insert into sys_role_menu values ('2', '1018');
insert into sys_role_menu values ('2', '1019');
insert into sys_role_menu values ('2', '1020');
insert into sys_role_menu values ('2', '1021');
insert into sys_role_menu values ('2', '1022');
insert into sys_role_menu values ('2', '1023');
insert into sys_role_menu values ('2', '1024');
insert into sys_role_menu values ('2', '1025');
insert into sys_role_menu values ('2', '1026');
insert into sys_role_menu values ('2', '1027');
insert into sys_role_menu values ('2', '1028');
insert into sys_role_menu values ('2', '1029');
insert into sys_role_menu values ('2', '1030');
insert into sys_role_menu values ('2', '1031');
insert into sys_role_menu values ('2', '1032');
insert into sys_role_menu values ('2', '1033');
insert into sys_role_menu values ('2', '1034');
insert into sys_role_menu values ('2', '1035');
insert into sys_role_menu values ('2', '1036');
insert into sys_role_menu values ('2', '1037');
insert into sys_role_menu values ('2', '1038');
insert into sys_role_menu values ('2', '1039');
insert into sys_role_menu values ('2', '1040');
insert into sys_role_menu values ('2', '1041');
insert into sys_role_menu values ('2', '1042');
insert into sys_role_menu values ('2', '1043');
insert into sys_role_menu values ('2', '1044');
insert into sys_role_menu values ('2', '1045');
insert into sys_role_menu values ('2', '1046');
insert into sys_role_menu values ('2', '1047');
insert into sys_role_menu values ('2', '1048');
insert into sys_role_menu values ('2', '1049');
insert into sys_role_menu values ('2', '1050');
insert into sys_role_menu values ('2', '1051');
insert into sys_role_menu values ('2', '1052');
insert into sys_role_menu values ('2', '1053');
insert into sys_role_menu values ('2', '1054');
insert into sys_role_menu values ('2', '1055');
insert into sys_role_menu values ('2', '1056');
insert into sys_role_menu values ('2', '1057');
insert into sys_role_menu values ('2', '1058');
insert into sys_role_menu values ('2', '1059');
insert into sys_role_menu values ('2', '1060');

-- ----------------------------
-- Table structure for SYS_SOURCE_CONFIG
-- ----------------------------
DROP TABLE "SYS_SOURCE_CONFIG";
CREATE TABLE "SYS_SOURCE_CONFIG" (
  "SOURCE_ID" NUMBER(20,0) NOT NULL,
  "SOURCE_CODE" VARCHAR2(50 BYTE),
  "PROJECT" VARCHAR2(50 BYTE),
  "PACKAGE_NAME" VARCHAR2(255 BYTE),
  "URL" VARCHAR2(150 BYTE),
  "USER_NAME" VARCHAR2(50 BYTE),
  "PASS_WORD" VARCHAR2(50 BYTE),
  "DRIVERS" VARCHAR2(100 BYTE),
  "DATABASE_TYPE" VARCHAR2(50 BYTE),
  "REMARK" NVARCHAR2(255),
  "ENABLE" VARCHAR2(255 BYTE)
);
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."SOURCE_ID" IS 'id';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."SOURCE_CODE" IS '数据源编码';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."PROJECT" IS '项目名称';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."PACKAGE_NAME" IS '切面声明包名称';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."URL" IS '连接信息';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."USER_NAME" IS '用户名';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."PASS_WORD" IS '密码';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."DRIVERS" IS '数据驱动类';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."DATABASE_TYPE" IS '数据库类型';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."REMARK" IS '备注说明';
COMMENT ON COLUMN "SYS_SOURCE_CONFIG"."ENABLE" IS '状态 true启用 false禁用';
COMMENT ON TABLE "SYS_SOURCE_CONFIG" IS '数据源配置';

-- ----------------------------
-- Records of SYS_SOURCE_CONFIG
-- ----------------------------
INSERT INTO "SYS_SOURCE_CONFIG" VALUES ('1', 'EASTUSER', 'EAST数据库', 'com.datashare.dataentryeast.mapper', 'jdbc:oracle:thin:@127.0.0.1:1521/orcl', 'EASTUSER', 'DB_L0gin_PassW0rd_er3$', 'oracle.jdbc.driver.OracleDriver', 'oracle', NULL, 'true');
INSERT INTO "SYS_SOURCE_CONFIG" VALUES ('2', 'DWUSER', 'DW数据库', 'com.datashare.dataentrydw.mapper', 'jdbc:oracle:thin:@127.0.0.1:1521/orcl', 'dwuser', 'DB_L0gin_PassW0rd_dr6$', 'oracle.jdbc.driver.OracleDriver', 'oracle', NULL, 'true');
INSERT INTO "SYS_SOURCE_CONFIG" VALUES ('3', 'ODSUSER', 'ODS数据库', 'com.datashare.dataentryods.mapper', 'jdbc:oracle:thin:@127.0.0.1:1521/orcl', 'odsuser', 'DB_L0gin_PassW0rd_or5$', 'oracle.jdbc.driver.OracleDriver', 'oracle', NULL, 'true');

-- ----------------------------
-- Table structure for SYS_TEST
-- ----------------------------
DROP TABLE "SYS_TEST";
CREATE TABLE "SYS_TEST" (
  "ID" NUMBER NOT NULL,
  "NAME" VARCHAR2(50 BYTE)
);
COMMENT ON COLUMN "SYS_TEST"."ID" IS 'ID';
COMMENT ON COLUMN "SYS_TEST"."NAME" IS '名称';

-- ----------------------------
-- Records of SYS_TEST
-- ----------------------------
INSERT INTO "SYS_TEST" VALUES ('1', '端木蓉');
INSERT INTO "SYS_TEST" VALUES ('2', '高渐离');

-- ----------------------------
-- Table structure for SYS_USER
-- ----------------------------
DROP TABLE "SYS_USER";
CREATE TABLE "SYS_USER" (
  "USER_ID" NUMBER(20,0) NOT NULL,
  "DEPT_ID" NUMBER(20,0) DEFAULT NULL,
  "USER_NAME" VARCHAR2(30 BYTE) NOT NULL,
  "NICK_NAME" VARCHAR2(30 BYTE) DEFAULT '',
  "USER_TYPE" VARCHAR2(2 BYTE) DEFAULT '00',
  "EMAIL" VARCHAR2(50 BYTE) DEFAULT '',
  "PHONENUMBER" VARCHAR2(11 BYTE) DEFAULT '',
  "SEX" CHAR(1 BYTE) DEFAULT '0',
  "AVATAR" VARCHAR2(100 BYTE) DEFAULT '',
  "PASSWORD" VARCHAR2(100 BYTE) DEFAULT '',
  "STATUS" CHAR(1 BYTE) DEFAULT '0',
  "DEL_FLAG" CHAR(1 BYTE) DEFAULT '0',
  "LOGIN_IP" VARCHAR2(128 BYTE) DEFAULT '',
  "LOGIN_DATE" DATE,
  "CREATE_BY" VARCHAR2(64 BYTE),
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(64 BYTE) DEFAULT '',
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(500 BYTE) DEFAULT ''
);
COMMENT ON COLUMN "SYS_USER"."USER_ID" IS '用户主键seq_sys_user.nextval';
COMMENT ON COLUMN "SYS_USER"."DEPT_ID" IS '部门ID';
COMMENT ON COLUMN "SYS_USER"."USER_NAME" IS '用户账号';
COMMENT ON COLUMN "SYS_USER"."NICK_NAME" IS '用户昵称';
COMMENT ON COLUMN "SYS_USER"."USER_TYPE" IS '用户类型（00系统用户 01注册用户）';
COMMENT ON COLUMN "SYS_USER"."EMAIL" IS '用户邮箱';
COMMENT ON COLUMN "SYS_USER"."PHONENUMBER" IS '手机号码';
COMMENT ON COLUMN "SYS_USER"."SEX" IS '用户性别（0男 1女 2未知）';
COMMENT ON COLUMN "SYS_USER"."AVATAR" IS '头像路径';
COMMENT ON COLUMN "SYS_USER"."PASSWORD" IS '密码';
COMMENT ON COLUMN "SYS_USER"."STATUS" IS '帐号状态（0正常 1停用）';
COMMENT ON COLUMN "SYS_USER"."DEL_FLAG" IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN "SYS_USER"."LOGIN_IP" IS '最后登录IP';
COMMENT ON COLUMN "SYS_USER"."LOGIN_DATE" IS '最后登录时间';
COMMENT ON COLUMN "SYS_USER"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "SYS_USER"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "SYS_USER"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "SYS_USER"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "SYS_USER"."REMARK" IS '备注';
COMMENT ON TABLE "SYS_USER" IS '用户信息表';

-- ----------------------------
-- Records of SYS_USER
-- ----------------------------
INSERT INTO "SYS_USER" VALUES ('1', '103', 'admin', '若依', '00', 'ry@163.com', '15888888888', '1', '/profile/avatar/2021/11/19/688ce643-4dc6-45b5-a6a0-1349bd7be623.jpeg', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', TO_DATE('2022-04-12 13:34:03', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2022-04-12 13:34:03', 'SYYYY-MM-DD HH24:MI:SS'), '管理员');
INSERT INTO "SYS_USER" VALUES ('2', '105', 'ry', '若依', '00', 'ry@qq.com', '15666666666', '1', NULL, '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), 'admin', TO_DATE('2021-11-16 09:42:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '测试员');

-- ----------------------------
-- Table structure for SYS_USER_POST
-- ----------------------------
DROP TABLE "SYS_USER_POST";
CREATE TABLE "SYS_USER_POST" (
  "USER_ID" NUMBER(20,0) NOT NULL,
  "POST_ID" NUMBER(20,0) NOT NULL
);
COMMENT ON COLUMN "SYS_USER_POST"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "SYS_USER_POST"."POST_ID" IS '岗位ID';
COMMENT ON TABLE "SYS_USER_POST" IS '用户与岗位关联表';

-- ----------------------------
-- Records of SYS_USER_POST
-- ----------------------------
INSERT INTO "SYS_USER_POST" VALUES ('1', '1');
INSERT INTO "SYS_USER_POST" VALUES ('2', '2');

-- ----------------------------
-- Table structure for SYS_USER_ROLE
-- ----------------------------
DROP TABLE "SYS_USER_ROLE";
CREATE TABLE "SYS_USER_ROLE" (
  "USER_ID" NUMBER(20,0) NOT NULL,
  "ROLE_ID" NUMBER(20,0) NOT NULL
);
COMMENT ON COLUMN "SYS_USER_ROLE"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "SYS_USER_ROLE"."ROLE_ID" IS '角色ID';
COMMENT ON TABLE "SYS_USER_ROLE" IS '用户和角色关联表';

-- ----------------------------
-- Records of SYS_USER_ROLE
-- ----------------------------
INSERT INTO "SYS_USER_ROLE" VALUES ('1', '1');
INSERT INTO "SYS_USER_ROLE" VALUES ('2', '2');

-- ----------------------------
-- Primary Key structure for table GEN_TABLE
-- ----------------------------
ALTER TABLE "GEN_TABLE" ADD CONSTRAINT "PK_GEN_TABLE" PRIMARY KEY ("TABLE_ID");


-- ----------------------------
-- Primary Key structure for table GEN_TABLE_COLUMN
-- ----------------------------
ALTER TABLE "GEN_TABLE_COLUMN" ADD CONSTRAINT "PK_GEN_TABLE_COLUMN" PRIMARY KEY ("COLUMN_ID");


-- ----------------------------
-- Primary Key structure for table SYS_CONFIG
-- ----------------------------
ALTER TABLE "SYS_CONFIG" ADD CONSTRAINT "PK_SYS_CONFIG" PRIMARY KEY ("CONFIG_ID");


-- ----------------------------
-- Primary Key structure for table SYS_DEPT
-- ----------------------------
ALTER TABLE "SYS_DEPT" ADD CONSTRAINT "PK_SYS_DEPT" PRIMARY KEY ("DEPT_ID");


-- ----------------------------
-- Primary Key structure for table SYS_DICT_DATA
-- ----------------------------
ALTER TABLE "SYS_DICT_DATA" ADD CONSTRAINT "PK_SYS_DICT_DATA" PRIMARY KEY ("DICT_CODE");


-- ----------------------------
-- Primary Key structure for table SYS_DICT_TYPE
-- ----------------------------
ALTER TABLE "SYS_DICT_TYPE" ADD CONSTRAINT "PK_SYS_DICT_TYPE" PRIMARY KEY ("DICT_ID");


-- ----------------------------
-- Indexes structure for table SYS_DICT_TYPE
-- ----------------------------
CREATE UNIQUE INDEX "SYS_DICT_TYPE_INDEX1"
  ON "SYS_DICT_TYPE" ("DICT_TYPE" ASC);

-- ----------------------------
-- Primary Key structure for table SYS_JOB
-- ----------------------------
ALTER TABLE "SYS_JOB" ADD CONSTRAINT "PK_SYS_JOB" PRIMARY KEY ("JOB_ID", "JOB_NAME", "JOB_GROUP");


-- ----------------------------
-- Primary Key structure for table SYS_JOB_LOG
-- ----------------------------
ALTER TABLE "SYS_JOB_LOG" ADD CONSTRAINT "PK_SYS_JOB_LOG" PRIMARY KEY ("JOB_LOG_ID");


-- ----------------------------
-- Primary Key structure for table SYS_LOGININFOR
-- ----------------------------
ALTER TABLE "SYS_LOGININFOR" ADD CONSTRAINT "PK_SYS_LOGININFOR" PRIMARY KEY ("INFO_ID");


-- ----------------------------
-- Primary Key structure for table SYS_MENU
-- ----------------------------
ALTER TABLE "SYS_MENU" ADD CONSTRAINT "PK_SYS_MENU" PRIMARY KEY ("MENU_ID");


-- ----------------------------
-- Primary Key structure for table SYS_NOTICE
-- ----------------------------
ALTER TABLE "SYS_NOTICE" ADD CONSTRAINT "PK_SYS_NOTICE" PRIMARY KEY ("NOTICE_ID");


-- ----------------------------
-- Primary Key structure for table SYS_OPER_LOG
-- ----------------------------
ALTER TABLE "SYS_OPER_LOG" ADD CONSTRAINT "PK_SYS_OPER_LOG" PRIMARY KEY ("OPER_ID");


-- ----------------------------
-- Primary Key structure for table SYS_POST
-- ----------------------------
ALTER TABLE "SYS_POST" ADD CONSTRAINT "PK_SYS_POST" PRIMARY KEY ("POST_ID");


-- ----------------------------
-- Primary Key structure for table SYS_ROLE
-- ----------------------------
ALTER TABLE "SYS_ROLE" ADD CONSTRAINT "PK_SYS_ROLE" PRIMARY KEY ("ROLE_ID");


-- ----------------------------
-- Primary Key structure for table SYS_ROLE_DEPT
-- ----------------------------
ALTER TABLE "SYS_ROLE_DEPT" ADD CONSTRAINT "PK_SYS_ROLE_DEPT" PRIMARY KEY ("ROLE_ID", "DEPT_ID");


-- ----------------------------
-- Primary Key structure for table SYS_ROLE_MENU
-- ----------------------------
ALTER TABLE "SYS_ROLE_MENU" ADD CONSTRAINT "PK_SYS_ROLE_MENU" PRIMARY KEY ("ROLE_ID", "MENU_ID");


-- ----------------------------
-- Primary Key structure for table SYS_SOURCE_CONFIG
-- ----------------------------
ALTER TABLE "SYS_SOURCE_CONFIG" ADD CONSTRAINT "SYS_C0016831" PRIMARY KEY ("SOURCE_ID");


-- ----------------------------
-- Primary Key structure for table SYS_TEST
-- ----------------------------
ALTER TABLE "SYS_TEST" ADD CONSTRAINT "SYS_C0017103" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table SYS_USER
-- ----------------------------
ALTER TABLE "SYS_USER" ADD CONSTRAINT "PK_SYS_USER" PRIMARY KEY ("USER_ID");


-- ----------------------------
-- Primary Key structure for table SYS_USER_POST
-- ----------------------------
ALTER TABLE "SYS_USER_POST" ADD CONSTRAINT "PK_SYS_USER_POST" PRIMARY KEY ("USER_ID", "POST_ID");


-- ----------------------------
-- Primary Key structure for table SYS_USER_ROLE
-- ----------------------------
ALTER TABLE "SYS_USER_ROLE" ADD CONSTRAINT "PK_SYS_USER_ROLE" PRIMARY KEY ("USER_ID", "ROLE_ID");

